UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tUgIozepxHbJ6yd2es3uRkDiogfH+Y3VaCd13zkrmQU='
WHERE
key_id = '1c53229d81a1cd010c124c8434b562d404afa387939e5a4020828429cf294b5a'
AND (
token = 'tUgIozepxHbJ6yd2es3uRkDiogfH+Y3VaCd13zkrmQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)