UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kI7ksT0HbyVHuXV4pis6CEsF44fcc3bUDB/tHfQjQl8='
WHERE
key_id = '7963f4d121be86a745977de8711963ab06a234ecacafb2209caee39784267bd5'
AND (
token = 'kI7ksT0HbyVHuXV4pis6CEsF44fcc3bUDB/tHfQjQl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)