UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eWRujF6mbRLa8JQyXY8lO8NXwT1hpdm0bWjKAvRJci8='
WHERE
key_id = 'a447d570dd88a404fc5c5975ede25f1c6ec91fcffe0b5aa8938bda373d11f8ff'
AND (
token = 'eWRujF6mbRLa8JQyXY8lO8NXwT1hpdm0bWjKAvRJci8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)