UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B8fuWzGaZkz3HOokIj7MjIEKF1tfXRfFT9hib+rJ4Zk='
WHERE
key_id = '2c5587be405df9ffa27318af59a18148ff87e1f2a21d336df692411f479c44ac'
AND (
token = 'B8fuWzGaZkz3HOokIj7MjIEKF1tfXRfFT9hib+rJ4Zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)