UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nwH99xJ09Nni78v8BAfKe4FlX8egb7ZcMx60QaPbDCM='
WHERE
key_id = 'f9d00b150aa93f4cf8a8353dfe99a2f28cae29bf07bdcf0467991c830cc79ebf'
AND (
token = 'nwH99xJ09Nni78v8BAfKe4FlX8egb7ZcMx60QaPbDCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)