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