UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jn4avghOUhcLtcCe6MxEaXYPci6WSuN7BPVl9s9O+RU='
WHERE
key_id = '292150d55ac3fbd938fdcfe30958c647ca43e1e23a10ee31b90f6e5e15391630'
AND (
token = 'jn4avghOUhcLtcCe6MxEaXYPci6WSuN7BPVl9s9O+RU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)