UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'asfxY5ffepSlj8DmnUO0rNTiwwzO+aC5eblAViHNzYQ='
WHERE
key_id = 'bf47b7d67370c9f91a5fbe1738a906aeeeae98c86078dec922e00a7731d99601'
AND (
token = 'asfxY5ffepSlj8DmnUO0rNTiwwzO+aC5eblAViHNzYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)