UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J1XfGj9rfJRn+YXF0DwfbnDcbBEe4Ijf6tCL9J6FkLY='
WHERE
key_id = '14fceaea2f595340e6ba310ebf97480a7b8fc4612a7e35c62b3f27d2211f647b'
AND (
token = 'J1XfGj9rfJRn+YXF0DwfbnDcbBEe4Ijf6tCL9J6FkLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)