UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LFR6QMFBSapkGqjudYe0+ILcT3xN9aasVhKFy2MijW8='
WHERE
key_id = '0e3d43cae5f188fb34fb76cb088830e8298a6054dde0ff424d75a06605a6786a'
AND (
token = 'LFR6QMFBSapkGqjudYe0+ILcT3xN9aasVhKFy2MijW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)