UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTcFZtPd66yu0gt5nRQg+RMkOTxVoe/8TIL5gmdYmq8='
WHERE
key_id = 'a199fbac67c6fa7663dd9d2726686ae15591ce8644d4a03e191fa37eb7938672'
AND (
token = 'ZTcFZtPd66yu0gt5nRQg+RMkOTxVoe/8TIL5gmdYmq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)