UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NXzx7lz3JOZDY2G8tKwPdsDQOmVETFu9Tgdks+BJsfs='
WHERE
key_id = '8d67345f04a654cebbb619cac34649b0cd6afd21c6a3a56edbd99b7690703254'
AND (
token = 'NXzx7lz3JOZDY2G8tKwPdsDQOmVETFu9Tgdks+BJsfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)