UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0gRDkkdTWWiMx1DoJC46sd8qxOEccvu9fRacLgEHdcM='
WHERE
key_id = '3558a5d886023392eb3c3772a89ce74fe7935d7ca9fe90a1e1df9031e3465966'
AND (
token = '0gRDkkdTWWiMx1DoJC46sd8qxOEccvu9fRacLgEHdcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)