UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E8uSlIYlQKPEYolSijkDSgc+qELCii2whUE7g1lGtgU='
WHERE
key_id = '6b00664da868d4b6a4948bda3ea33a2dcdaf0368c95d814b9dd09b6c5b8a16c9'
AND (
token = 'E8uSlIYlQKPEYolSijkDSgc+qELCii2whUE7g1lGtgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)