UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0jzklHCQ326fdNW0kEGa05UQ89a7VaiZ8pJ9MxgwdOc='
WHERE
key_id = '12a2d54428a0a89b6272db09939657f943d801a7a80d2af1453e14b6cff3bd98'
AND (
token = '0jzklHCQ326fdNW0kEGa05UQ89a7VaiZ8pJ9MxgwdOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)