UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUa6FU517v5BigkZNuQ1tDKpbLUIa2nDGt7X/o1jvQI='
WHERE
key_id = 'd3da2dc3426f81d4efd4bedaa98590af49449120c0fd2a03caa9a65382a4431a'
AND (
token = 'nUa6FU517v5BigkZNuQ1tDKpbLUIa2nDGt7X/o1jvQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)