UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rZe8NQ0yDXW+AvoTdzFo4aX5uyhBpmXWfREYVqIPvHE='
WHERE
key_id = 'c3999fd45ca8bf0806292140c0da6f05e4ab102c71018f2f4877e61371e8a5ce'
AND (
token = 'rZe8NQ0yDXW+AvoTdzFo4aX5uyhBpmXWfREYVqIPvHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)