UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oA8Xv6ht6EAZT+gpfcNG59Btb4YzC+J2RaRV7++RJGE='
WHERE
key_id = 'b95fa7e44a43db9685bdbf7bcfe513ec017d4424ceb8ac35e987fe89cb0ac3b1'
AND (
token = 'oA8Xv6ht6EAZT+gpfcNG59Btb4YzC+J2RaRV7++RJGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)