UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31pSZrRfm//5HYAP8TQtjQSV0WxKOQi8MJRQm2mf4ME='
WHERE
key_id = 'c295cdd5dfe3bd2f0eed952d4671168e29a32bdf0df12fa0f1eb153528d4a9cd'
AND (
token = '31pSZrRfm//5HYAP8TQtjQSV0WxKOQi8MJRQm2mf4ME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)