UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7TLsF49fwrpVZihEfvwuayZZMRVnd1GnDz25sZuKvT8='
WHERE
key_id = '3cecfd2d79f707753a9f6e19019d06705871baff36c657cba380125c5f9945ce'
AND (
token = '7TLsF49fwrpVZihEfvwuayZZMRVnd1GnDz25sZuKvT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)