UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3yW7Ts0xse4ii/NdghLbdVTy5xo0sI8eIHopWG2G4LU='
WHERE
key_id = '428e5c4dbe6188488c9d0c343eac85ffc5215b0315ea420c7943caad5c95a382'
AND (
token = '3yW7Ts0xse4ii/NdghLbdVTy5xo0sI8eIHopWG2G4LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)