UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DqPdxitvZzqzgt8yUPo8SB3BX/aBPzCAU68M2mAXi/U='
WHERE
key_id = '8647ce9920842e27f3612c62b20b4c0b1b9b5b4e3dffe7a540c4754487a68762'
AND (
token = 'DqPdxitvZzqzgt8yUPo8SB3BX/aBPzCAU68M2mAXi/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)