UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P/Xwv6OuJgHkfxCBFWd+fvJMVi8LimpsBq/sTp01+zE='
WHERE
key_id = '8db0b353454d63149b282301e9f21d5287496c9e44308f334b7a92efb3292c31'
AND (
token = 'P/Xwv6OuJgHkfxCBFWd+fvJMVi8LimpsBq/sTp01+zE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)