UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v1tMhB0389kaGhjkLO4sjdLHgx5sc0i7ilt0WyMjf5Q='
WHERE
key_id = '1a5767393e17d245556c8fd67504ef04acb35dc8d5960e7982001691fa958e70'
AND (
token = 'v1tMhB0389kaGhjkLO4sjdLHgx5sc0i7ilt0WyMjf5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)