UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JozBIwym+snqu8bv8qMLBPoH7fMNVQIJ2nTSkI2qXm4='
WHERE
key_id = 'd1486ccfb666b7852ce1be462313d69aac94add321200a43cab7ccd49fb01dc8'
AND (
token = 'JozBIwym+snqu8bv8qMLBPoH7fMNVQIJ2nTSkI2qXm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)