UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qPdNEOdcnM9MloUwsY86JYm4ew7G+k3yMS9tvYc93S0='
WHERE
key_id = 'a00ef0464058e42ed047e2c74019e11064409571b8fa858f4e8cd1929d0570d4'
AND (
token = 'qPdNEOdcnM9MloUwsY86JYm4ew7G+k3yMS9tvYc93S0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)