UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PCaXqSg7pKqDalPNMeLIPxHeCQG/cQttENCu8zbSGOQ='
WHERE
key_id = 'eb4423381252b6a48dcf1a4fab1505115f8b1178332a34e9bbd84e24e4f3d20e'
AND (
token = 'PCaXqSg7pKqDalPNMeLIPxHeCQG/cQttENCu8zbSGOQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)