UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x9bJAWTM/9JCiXyXU3GJ61R1HTj900QU1XpY/yRahSA='
WHERE
key_id = '4e29c92a02f63b419ebb026d4b389dc79388ba754c7f89dc103d2da07222c753'
AND (
token = 'x9bJAWTM/9JCiXyXU3GJ61R1HTj900QU1XpY/yRahSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)