UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q0eq9gYrkS7GOdxbzLDwv07e0cUJoaLLTBs1yJkWgmU='
WHERE
key_id = '47dc0a40464b7c99a07ad9af93d22ef2fe0207bcff0a1ec57257164783f53ce2'
AND (
token = 'q0eq9gYrkS7GOdxbzLDwv07e0cUJoaLLTBs1yJkWgmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)