UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3GFYMuN0zvTy7dcZRvr+1Oihq5oDnbzng5a24z9SXms='
WHERE
key_id = '8c371538d47e78debdc5e46f0ff0faffaba0095e8aa8b032c75e9c2b2216cafb'
AND (
token = '3GFYMuN0zvTy7dcZRvr+1Oihq5oDnbzng5a24z9SXms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)