UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd1FW7Qg61sUdh5UOPOOIzPR+3jatdoBNiuTSE8gQadM='
WHERE
key_id = '0cff920ebe6e0762d87fec06729b151c36668bd91b95a2eafd234d261064baf9'
AND (
token = 'd1FW7Qg61sUdh5UOPOOIzPR+3jatdoBNiuTSE8gQadM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)