UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VhD2blafebB8Q6CbdjHm4f0JxW3lm8z6s8rOX7BN3Kw='
WHERE
key_id = '386747392c6bdbeabd1452a381ac096f1e2de2d8540e6fad0124d9ec08016327'
AND (
token = 'VhD2blafebB8Q6CbdjHm4f0JxW3lm8z6s8rOX7BN3Kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)