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